<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateRefundAfterSaleManagementsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {   //退款售后管理
        Schema::create('refund_after_sale_managements', function (Blueprint $table) {
            $table->increments('id');
            //订单编号
            $table->string('order_num')->nullable();
            //退款编号
            $table->string('refund_num')->nullable();
            //支付宝交易号
            $table->string('alipay_trade_num')->nullable();
            //买家会员名称
            $table->string('buyer_member_name')->nullable();
            //总金额
            $table->string('total_money')->nullable();
            //买家实际支付金额
            $table->string('buyer_actually_pay_money')->nullable();
            //宝贝标题
            $table->string('commodity_title')->nullable();
            //买家退款金额
            $table->string('buyer_refund_money')->nullable();
            //部分退款/全额退款
            $table->string('is_total_refund')->nullable();
            //手工退款/系统退款
            $table->string('refund_way')->nullable();
            //是否需要退货
            $table->string('is_need_sales_return')->nullable();
            //退款的申请时间
            $table->string('refund_applied_at')->nullable();
            //超时时间
            $table->string('overtime_at')->nullable();
            //退款状态
            $table->string('refund_status')->nullable();
            //货物状态
            $table->string('commodity_status')->nullable();
            //客服介入状态
            $table->string('service_intervene_status')->nullable();
            //卖家内部处理人员
            $table->string('seller_internal_operator')->nullable();
            //卖家真实姓名
            $table->string('seller_true_name')->nullable();
            //卖家退货地址
            $table->string('seller_address_for_return_delivery')->nullable();
            //卖家邮编
            $table->string('seller_postcode')->nullable();
            //卖家电话
            $table->string('seller_phone')->nullable();
            //卖家手机
            $table->string('seller_mobile')->nullable();
            //退货物流类型
            $table->string('logistics_num')->nullable();
            //退货物流公司
            $table->string('logistics_company')->nullable();
            //退货订单号
            $table->string('sales_return_order_num')->nullable();
            //买家退款原因
            $table->string('buyer_refund_reason')->nullable();
            //买家退款说明
            $table->string('buyer_refund_state')->nullable();
            //买家退货时间
            $table->string('buyer_returns_at')->nullable();
            //售中或售后
            $table->string('after_sale')->nullable();
            //责任方
            $table->string('responsible_party')->nullable();
            //完结时间（天）
            $table->string('finsh_time')->nullable();
            //是否零秒响应
            $table->string('is_respond_immediately')->nullable();
            // $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('refund_after_sale_managements');
    }
}
